object Form1: TForm1
  Left = 229
  Top = 175
  Width = 1030
  Height = 640
  Caption = #26597#35810
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  WindowState = wsMaximized
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object PageControl1: TPageControl
    Left = 0
    Top = 0
    Width = 1022
    Height = 606
    ActivePage = TabSheet2
    Align = alClient
    TabOrder = 0
    object TabSheet1: TTabSheet
      Caption = #37319#36141#37096#21508#20998#31867#38144#21806
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
      object Panel1: TPanel
        Left = 0
        Top = 0
        Width = 1014
        Height = 81
        Align = alTop
        Font.Charset = ANSI_CHARSET
        Font.Color = clWindowText
        Font.Height = -16
        Font.Name = #23435#20307
        Font.Style = []
        ParentBackground = False
        ParentFont = False
        TabOrder = 0
        object Label1: TLabel
          Left = 8
          Top = 15
          Width = 51
          Height = 16
          Caption = #26085#26399#65306
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -16
          Font.Name = #23435#20307
          Font.Style = [fsBold]
          ParentFont = False
        end
        object Label2: TLabel
          Left = 344
          Top = 15
          Width = 68
          Height = 16
          Caption = #37319#36141#37096#65306
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -16
          Font.Name = #23435#20307
          Font.Style = [fsBold]
          ParentFont = False
        end
        object Shape1: TShape
          Left = 180
          Top = 21
          Width = 25
          Height = 2
        end
        object LBL_BM: TLabel
          Left = 408
          Top = 16
          Width = 27
          Height = 16
          Caption = '401'
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -16
          Font.Name = #23435#20307
          Font.Style = [fsBold]
          ParentFont = False
        end
        object DT1: TDateTimePicker
          Left = 56
          Top = 11
          Width = 120
          Height = 24
          Date = 40547.823990891200000000
          Format = 'yyyy-MM-dd'
          Time = 40547.823990891200000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 0
        end
        object DT2: TDateTimePicker
          Left = 210
          Top = 11
          Width = 120
          Height = 24
          Date = 40547.824039722230000000
          Format = 'yyyy-MM-dd'
          Time = 40547.824039722230000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 1
        end
        object ComboBox1: TComboBox
          Left = 436
          Top = 11
          Width = 100
          Height = 24
          Style = csDropDownList
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          ItemHeight = 16
          ItemIndex = 1
          TabOrder = 2
          Text = #37319#36141#19968#37096
          OnChange = ComboBox1Change
          Items.Strings = (
            ''
            #37319#36141#19968#37096
            #37319#36141#20108#37096
            #37319#36141#19977#37096
            #37319#36141#22235#37096
            #37319#36141#20116#37096)
        end
        object Button1: TButton
          Left = 530
          Top = 48
          Width = 75
          Height = 25
          Caption = #26597#35810
          TabOrder = 3
          OnClick = Button1Click
        end
        object Memo1: TMemo
          Left = 1048
          Top = 8
          Width = 201
          Height = 25
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            
              'select dl,b.catcname,sum(thisxssr) as bnxs ,sum(lastxssr) as qnx' +
              's from ('
            
              'SELECT fgetgoodscatpcode(tc.scdcatid, 1) dl, fgetgoodscatpcode(t' +
              'c.scdcatid, 2) zl,'
            
              '       fgetgoodscatpcode(tc.scdcatid, 3) catcode, SUM(nvl(thisxs' +
              'sr, 0)) thisxssr,'
            '       SUM(nvl(lastxssr, 0)) lastxssr,'
            '       decode(SUM(nvl(lastxssr, 0)), 0, 0,'
            
              '               round((SUM(nvl(thisxssr, 0)) - SUM(nvl(lastxssr, ' +
              '0))) / SUM(nvl(lastxssr, 0)), 4)) ext'
            '  FROM (SELECT scdcatid, SUM(nvl(xssr + pfsr, 0)) thisxssr'
            '           FROM salecostday, manaframe'
            
              '          WHERE salecostday.scddate <= to_date(:rq2, '#39'YYYY-MM-DD' +
              #39')'
            
              '            AND salecostday.scddate >= to_date(:rq1, '#39'YYYY-MM-DD' +
              #39')'
            '            AND salecostday.scdcatid IN (SELECT catcode'
            '                                           FROM goodscat'
            
              '                                          WHERE goodscat.catmfid' +
              ' = :bm)'
            '            AND scdmfid = mfcode'
            '            AND mfpcode LIKE '#39#39' || '#39'%'#39
            '            AND mffcode LIKE '#39#39' || '#39'%'#39
            '          GROUP BY scdcatid) ta,'
            '       (SELECT scdcatid, SUM(nvl(xssr + pfsr, 0)) lastxssr'
            '           FROM salecostday, manaframe'
            
              '          WHERE scddate <= add_months(to_date(:rq2, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            
              '            AND scddate >= add_months(to_date(:rq1, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            '            AND salecostday.scdcatid IN (SELECT catcode'
            '                                           FROM goodscat'
            
              '                                          WHERE goodscat.catmfid' +
              ' = :bm)'
            '            AND scdmfid = mfcode'
            '            AND mfpcode LIKE '#39#39' || '#39'%'#39
            '            AND mffcode LIKE '#39#39' || '#39'%'#39
            '          GROUP BY scdcatid) tb,'
            '       (SELECT catcode scdcatid'
            '           FROM goodscat'
            '          WHERE catflag = '#39'Y'#39
            '            AND goodscat.catmfid = :bm'
            '         UNION'
            '         SELECT DISTINCT scdcatid'
            '           FROM salecostday, manaframe'
            
              '          WHERE scddate <= add_months(to_date(:rq2, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            
              '            AND scddate >= add_months(to_date(:rq1, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            '            AND scdmfid = mfcode'
            '            AND mfpcode LIKE '#39#39' || '#39'%'#39
            '            AND mffcode LIKE '#39#39' || '#39'%'#39
            '            AND salecostday.scdcatid IN (SELECT catcode'
            '                                           FROM goodscat'
            
              '                                          WHERE goodscat.catmfid' +
              ' = :bm)'
            '          GROUP BY scdcatid) tc'
            ' WHERE tc.scdcatid = ta.scdcatid(+)'
            '   AND tc.scdcatid = tb.scdcatid(+)'
            
              ' GROUP BY fgetgoodscatpcode(tc.scdcatid, 1), fgetgoodscatpcode(t' +
              'c.scdcatid, 2),'
            '          fgetgoodscatpcode(tc.scdcatid, 3)'
            
              'HAVING SUM(nvl(thisxssr, 0)) <> 0 OR SUM(nvl(lastxssr, 0)) <> 0 ' +
              ') simon,goodscat b'
            'where simon.dl=b.catcode'
            'group by dl,b.catcname/*'#21435#24180#26377#38144#21806#30340#20170#24180#27809#26377#38144#21806#30340#65292#20170#24180#26377#38144#21806#30340#21435#24180#27809#26377#38144#21806#30340#37117#35201#26174#31034'*/'
            'order by dl')
          TabOrder = 4
          Visible = False
          WordWrap = False
        end
        object Button2: TButton
          Left = 666
          Top = 48
          Width = 75
          Height = 25
          Caption = #23548#20986
          Enabled = False
          TabOrder = 5
          OnClick = Button2Click
        end
        object Memo2: TMemo
          Left = 1056
          Top = 40
          Width = 201
          Height = 33
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            
              'select dl,b.catcname,sum(thisxssr) as bnxs ,sum(lastxssr) as qnx' +
              's from ('
            
              'SELECT fgetgoodscatpcode(tc.scdcatid, 1) dl, fgetgoodscatpcode(t' +
              'c.scdcatid, 2) zl,'
            
              '       fgetgoodscatpcode(tc.scdcatid, 3) catcode, SUM(nvl(thisxs' +
              'sr, 0)) thisxssr,'
            '       SUM(nvl(lastxssr, 0)) lastxssr,'
            '       decode(SUM(nvl(lastxssr, 0)), 0, 0,'
            
              '               round((SUM(nvl(thisxssr, 0)) - SUM(nvl(lastxssr, ' +
              '0))) / SUM(nvl(lastxssr, 0)), 4)) ext'
            '  FROM (SELECT scdcatid, SUM(nvl(xssr + pfsr, 0)) thisxssr'
            '           FROM salecostday, manaframe'
            
              '          WHERE salecostday.scddate <= to_date(:rq2, '#39'YYYY-MM-DD' +
              #39')'
            
              '            AND salecostday.scddate >= to_date(:rq1, '#39'YYYY-MM-DD' +
              #39')'
            '            AND salecostday.scdcatid IN'
            '                (SELECT catcode'
            '                   FROM goodscat'
            '                  WHERE '#39'GOODSCAT.CATMFID'#39' = '#39'GOODSCAT.CATMFID'#39')'
            '            AND scdmfid = mfcode'
            '            AND mfpcode LIKE '#39#39' || '#39'%'#39
            '            AND mffcode LIKE '#39#39' || '#39'%'#39
            '          GROUP BY scdcatid) ta,'
            '       (SELECT scdcatid, SUM(nvl(xssr + pfsr, 0)) lastxssr'
            '           FROM salecostday, manaframe'
            
              '          WHERE scddate <= add_months(to_date(:rq2, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            
              '            AND scddate >= add_months(to_date(:rq1, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            '            AND salecostday.scdcatid IN'
            '                (SELECT catcode'
            '                   FROM goodscat'
            '                  WHERE '#39'GOODSCAT.CATMFID'#39' = '#39'GOODSCAT.CATMFID'#39')'
            '            AND scdmfid = mfcode'
            '            AND mfpcode LIKE '#39#39' || '#39'%'#39
            '            AND mffcode LIKE '#39#39' || '#39'%'#39
            '          GROUP BY scdcatid) tb,'
            '       (SELECT catcode scdcatid'
            '           FROM goodscat'
            '          WHERE catflag = '#39'Y'#39
            '            AND '#39'GOODSCAT.CATMFID'#39' = '#39'GOODSCAT.CATMFID'#39
            '         UNION'
            '         SELECT DISTINCT scdcatid'
            '           FROM salecostday, manaframe'
            
              '          WHERE scddate <= add_months(to_date(:rq2, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            
              '            AND scddate >= add_months(to_date(:rq1, '#39'YYYY-MM-DD'#39 +
              '), -12)'
            '            AND scdmfid = mfcode'
            '            AND mfpcode LIKE '#39#39' || '#39'%'#39
            '            AND mffcode LIKE '#39#39' || '#39'%'#39
            '            AND salecostday.scdcatid IN'
            '                (SELECT catcode'
            '                   FROM goodscat'
            '                  WHERE '#39'GOODSCAT.CATMFID'#39' = '#39'GOODSCAT.CATMFID'#39')'
            '          GROUP BY scdcatid) tc'
            ' WHERE tc.scdcatid = ta.scdcatid(+)'
            '   AND tc.scdcatid = tb.scdcatid(+)'
            
              ' GROUP BY fgetgoodscatpcode(tc.scdcatid, 1), fgetgoodscatpcode(t' +
              'c.scdcatid, 2),'
            '          fgetgoodscatpcode(tc.scdcatid, 3)'
            
              'HAVING SUM(nvl(thisxssr, 0)) <> 0 OR SUM(nvl(lastxssr, 0)) <> 0 ' +
              ') simon,goodscat b'
            'where simon.dl=b.catcode'
            'group by dl,b.catcname/*'#21435#24180#26377#38144#21806#30340#20170#24180#27809#26377#38144#21806#30340#65292#20170#24180#26377#38144#21806#30340#21435#24180#27809#26377#38144#21806#30340#37117#35201#26174#31034'*/'
            'order by dl')
          TabOrder = 6
          Visible = False
          WordWrap = False
        end
      end
      object Panel2: TPanel
        Left = 0
        Top = 81
        Width = 1014
        Height = 497
        Align = alClient
        ParentBackground = False
        TabOrder = 1
        object DBGridEh1: TDBGridEh
          Left = 1
          Top = 1
          Width = 1012
          Height = 495
          Align = alClient
          DataSource = DataSource1
          ShowSerialNo = False
          Flat = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -16
          Font.Name = #23435#20307
          Font.Style = []
          FooterColor = clWindow
          FooterFont.Charset = DEFAULT_CHARSET
          FooterFont.Color = clWindowText
          FooterFont.Height = -11
          FooterFont.Name = 'MS Sans Serif'
          FooterFont.Style = []
          FooterRowCount = 1
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          ParentFont = False
          SumList.Active = True
          TabOrder = 0
          TitleFont.Charset = ANSI_CHARSET
          TitleFont.Color = clWindowText
          TitleFont.Height = -16
          TitleFont.Name = #23435#20307
          TitleFont.Style = []
          Columns = <
            item
              EditButtons = <>
              FieldName = 'DL'
              Footers = <>
              Title.Caption = #20195#30721
              Width = 31
            end
            item
              EditButtons = <>
              FieldName = 'CATCNAME'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -16
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.Value = #26412#37096#38376#21512#35745#65306
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #22823#31867#21517#31216
              Width = 213
            end
            item
              EditButtons = <>
              FieldName = 'BNXS'
              Footer.FieldName = 'BNXS'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -16
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #26412#24180#38144#21806
              Width = 172
            end
            item
              EditButtons = <>
              FieldName = 'QNXS'
              Footer.FieldName = 'QNXS'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -16
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #21435#24180#38144#21806
              Width = 175
            end
            item
              Alignment = taRightJustify
              EditButtons = <>
              FieldName = 'TB'
              Footer.Alignment = taRightJustify
              Footer.FieldName = 'TB'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -16
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #21516#27604
              Width = 95
            end>
        end
      end
    end
    object TabSheet2: TTabSheet
      Caption = #25353#20998#31867#30340#23703#32452#36149#23486#20998#26512
      ImageIndex = 1
      object Panel3: TPanel
        Left = 0
        Top = 0
        Width = 1014
        Height = 81
        Align = alTop
        Font.Charset = ANSI_CHARSET
        Font.Color = clWindowText
        Font.Height = -16
        Font.Name = #23435#20307
        Font.Style = []
        ParentBackground = False
        ParentFont = False
        TabOrder = 0
        object Label3: TLabel
          Left = 8
          Top = 15
          Width = 51
          Height = 16
          Caption = #26085#26399#65306
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -16
          Font.Name = #23435#20307
          Font.Style = [fsBold]
          ParentFont = False
        end
        object Shape2: TShape
          Left = 180
          Top = 21
          Width = 25
          Height = 2
        end
        object DateTimePicker1: TDateTimePicker
          Left = 56
          Top = 11
          Width = 120
          Height = 24
          Date = 40547.823990891200000000
          Format = 'yyyy-MM-dd'
          Time = 40547.823990891200000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 0
        end
        object DateTimePicker2: TDateTimePicker
          Left = 210
          Top = 11
          Width = 120
          Height = 24
          Date = 40547.824039722230000000
          Format = 'yyyy-MM-dd'
          Time = 40547.824039722230000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 1
        end
        object Button3: TButton
          Left = 530
          Top = 48
          Width = 75
          Height = 25
          Caption = #26597#35810
          TabOrder = 2
          OnClick = Button3Click
        end
        object Memo3: TMemo
          Left = 968
          Top = 48
          Width = 201
          Height = 25
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            
              'select CATIDD,catidd||'#39' '#39'||goodscat.catcname AS CATCAMEE, b11080' +
              '3.MFID,Manaframe.Mfcname,'
            'b110803.XSSR,b110803.XSSL,b110803.VIPXSSR,b110803.VIPXSSL,'
            
              'round( decode(b110803.XSSR,0,0,b110803.VIPXSSR/b110803.XSSR*100)' +
              ',2)as VXSTB,'
            
              'round( decode(b110803.XSSL,0,0,b110803.VIPXSSL/b110803.XSSL*100)' +
              ',2)as VXSLTB, '
            
              'b110803.LASTXSSR,b110803.LASTXSSL,b110803.LASTVIPXSSR,b110803.LA' +
              'STVIPXSSL,'
            
              'round( decode(b110803.LASTXSSR,0,0,b110803.LASTVIPXSSR/b110803.L' +
              'ASTXSSR*100),2)as LVXSTB,'
            
              'round( decode(b110803.LASTXSSL,0,0,b110803.LASTVIPXSSL/b110803.L' +
              'ASTXSSL*100),2)as LVXSLTB'
            ' from ('
            'select a110803.*,substr(sglcatid,1,2) catidd from ('
            
              'SELECT mfid,sglcatid, SUM(nvl(instr(flag, '#39'1'#39') * xssr, 0)) xssr,' +
              ' SUM(nvl(instr(flag, '#39'1'#39') * xssl, 0)) xssl,'
            '       SUM(nvl(instr(flag, '#39'1'#39') * vipxssr, 0)) vipxssr,'
            '       SUM(nvl(instr(flag, '#39'1'#39') * vipxssl, 0)) vipxssl,'
            
              '       SUM(nvl(instr(flag, '#39'2'#39') * xssr, 0)) lastxssr, SUM(nvl(in' +
              'str(flag, '#39'2'#39') * xssl, 0)) lastxssl,'
            '       SUM(nvl(instr(flag, '#39'2'#39') * vipxssr, 0)) lastvipxssr,'
            '       SUM(nvl(instr(flag, '#39'2'#39') * vipxssl, 0)) lastvipxssl'
            
              '  FROM (SELECT '#39'1'#39' flag, sglmfid mfid,sglcatid, SUM(sglxssr) xss' +
              'r, SUM(sglsl) xssl, SUM(sglcustsr) vipxssr,'
            
              '                SUM(decode(sign(sglcustsr - 0), -1, sglsl, 1, sg' +
              'lsl, 0)) vipxssl'
            '           FROM salegoodslist'
            '          WHERE sgldate >= to_date(:rq1, '#39'yyyy-mm-dd'#39')'
            '            AND sgldate <= to_date(:rq2, '#39'yyyy-mm-dd'#39')'
            '            AND salegoodslist.sglmarket = '#39'205'#39
            
              '            AND '#39'SALEGOODSLIST.SGLMFID'#39' = '#39'SALEGOODSLIST.SGLMFID' +
              #39
            '          GROUP BY sglmfid,sglcatid'
            '         UNION ALL'
            
              '         SELECT '#39'2'#39' flag, sglmfid mfid,sglcatid, SUM(sglxssr) la' +
              'stxssr, SUM(sglsl) lastxssl,'
            '                SUM(sglcustsr) lastvipxssr,'
            
              '                SUM(decode(sign(sglcustsr - 0), -1, sglsl, 1, sg' +
              'lsl, 0)) lastvipxssl'
            '           FROM salegoodslist'
            
              '          WHERE sgldate >= add_months(to_date(:rq1, '#39'yyyy-mm-dd'#39 +
              '), -12)'
            
              '            AND sgldate <= add_months(to_date(:rq2, '#39'yyyy-mm-dd'#39 +
              '), -12)'
            '            AND salegoodslist.sglmarket = '#39'205'#39
            
              '            AND '#39'SALEGOODSLIST.SGLMFID'#39' = '#39'SALEGOODSLIST.SGLMFID' +
              #39
            '          GROUP BY sglmfid,sglcatid)'
            ' GROUP BY mfid,sglcatid'
            
              ' ) a110803,goodscat where sglcatid= goodscat.catcode order by mf' +
              'id'
            
              ' )  b110803,goodscat,Manaframe where catidd=goodscat.catcode and' +
              ' mfid=Manaframe.mfcode'
            ' order by CATIDD,catidd||'#39' '#39'||goodscat.catcname,b110803.MFID')
          TabOrder = 3
          Visible = False
          WordWrap = False
        end
        object Button4: TButton
          Left = 666
          Top = 48
          Width = 75
          Height = 25
          Caption = #23548#20986
          Enabled = False
          TabOrder = 4
          OnClick = Button4Click
        end
        object Memo4: TMemo
          Left = 968
          Top = 16
          Width = 201
          Height = 25
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            
              'select CATIDD,catidd||'#39' '#39'||goodscat.catcname AS CATCAMEE,'#39#39' AS M' +
              'FID,'#39#39' AS MFCNAME, sum(b110803.XSSR) as XSSR,'
            
              'sum(b110803.XSSL) as XSSL,sum(b110803.VIPXSSR) as VIPXSSR,sum(b1' +
              '10803.VIPXSSL) as VIPXSSL,'
            
              'sum(round( decode(b110803.XSSR,0,0,b110803.VIPXSSR/b110803.XSSR*' +
              '100),2))as VXSTB,'
            
              'sum(round( decode(b110803.XSSL,0,0,b110803.VIPXSSL/b110803.XSSL*' +
              '100),2))as VXSLTB, '
            
              'sum(b110803.LASTXSSR) as LASTXSSR,sum(b110803.LASTXSSL) as LASTX' +
              'SSL,'
            
              'sum(b110803.LASTVIPXSSR) as LASTVIPXSSR,sum(b110803.LASTVIPXSSL)' +
              ' as LASTVIPXSSL,'
            
              'sum(round( decode(b110803.LASTXSSR,0,0,b110803.LASTVIPXSSR/b1108' +
              '03.LASTXSSR*100),2))as LVXSTB,'
            
              'sum(round( decode(b110803.LASTXSSL,0,0,b110803.LASTVIPXSSL/b1108' +
              '03.LASTXSSL*100),2))as LVXSLTB'
            ' from ('
            'select a110803.*,substr(sglcatid,1,2) catidd from ('
            
              'SELECT mfid,sglcatid, SUM(nvl(instr(flag, '#39'1'#39') * xssr, 0)) xssr,' +
              ' SUM(nvl(instr(flag, '#39'1'#39') * xssl, 0)) xssl,'
            '       SUM(nvl(instr(flag, '#39'1'#39') * vipxssr, 0)) vipxssr,'
            '       SUM(nvl(instr(flag, '#39'1'#39') * vipxssl, 0)) vipxssl,'
            
              '       SUM(nvl(instr(flag, '#39'2'#39') * xssr, 0)) lastxssr, SUM(nvl(in' +
              'str(flag, '#39'2'#39') * xssl, 0)) lastxssl,'
            '       SUM(nvl(instr(flag, '#39'2'#39') * vipxssr, 0)) lastvipxssr,'
            '       SUM(nvl(instr(flag, '#39'2'#39') * vipxssl, 0)) lastvipxssl'
            
              '  FROM (SELECT '#39'1'#39' flag, sglmfid mfid,sglcatid, SUM(sglxssr) xss' +
              'r, SUM(sglsl) xssl, SUM(sglcustsr) vipxssr,'
            
              '                SUM(decode(sign(sglcustsr - 0), -1, sglsl, 1, sg' +
              'lsl, 0)) vipxssl'
            '           FROM salegoodslist'
            '          WHERE sgldate >= to_date(:rq1, '#39'yyyy-mm-dd'#39')'
            '            AND sgldate <= to_date(:rq2, '#39'yyyy-mm-dd'#39')'
            '            AND salegoodslist.sglmarket = '#39'205'#39
            
              '            AND '#39'SALEGOODSLIST.SGLMFID'#39' = '#39'SALEGOODSLIST.SGLMFID' +
              #39
            '          GROUP BY sglmfid,sglcatid'
            '         UNION ALL'
            
              '         SELECT '#39'2'#39' flag, sglmfid mfid,sglcatid, SUM(sglxssr) la' +
              'stxssr, SUM(sglsl) lastxssl,'
            '                SUM(sglcustsr) lastvipxssr,'
            
              '                SUM(decode(sign(sglcustsr - 0), -1, sglsl, 1, sg' +
              'lsl, 0)) lastvipxssl'
            '           FROM salegoodslist'
            
              '          WHERE sgldate >= add_months(to_date(:rq1, '#39'yyyy-mm-dd'#39 +
              '), -12)'
            
              '            AND sgldate <= add_months(to_date(:rq2, '#39'yyyy-mm-dd'#39 +
              '), -12)'
            '            AND salegoodslist.sglmarket = '#39'205'#39
            
              '            AND '#39'SALEGOODSLIST.SGLMFID'#39' = '#39'SALEGOODSLIST.SGLMFID' +
              #39
            '          GROUP BY sglmfid,sglcatid)'
            ' GROUP BY mfid,sglcatid'
            
              ' ) a110803,goodscat where sglcatid= goodscat.catcode order by mf' +
              'id'
            
              ' )  b110803,goodscat,Manaframe where catidd=goodscat.catcode and' +
              ' mfid=Manaframe.mfcode'
            'group by catidd,catidd||'#39' '#39'||goodscat.catcname')
          TabOrder = 5
          Visible = False
          WordWrap = False
        end
        object RadioButton1: TRadioButton
          Left = 344
          Top = 20
          Width = 105
          Height = 17
          Caption = #25353#22823#31867#27719#24635
          Checked = True
          TabOrder = 6
          TabStop = True
          OnClick = RadioButton1Click
        end
        object RadioButton2: TRadioButton
          Left = 344
          Top = 44
          Width = 137
          Height = 17
          Caption = #26174#31034#31867#21035#12289#23703#32452
          TabOrder = 7
          OnClick = RadioButton2Click
        end
      end
      object Panel4: TPanel
        Left = 0
        Top = 81
        Width = 1014
        Height = 497
        Align = alClient
        ParentBackground = False
        TabOrder = 1
        object DBGridEh2: TDBGridEh
          Left = 1
          Top = 1
          Width = 1012
          Height = 495
          Align = alClient
          DataSource = DataSource2
          ShowSerialNo = False
          Flat = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -14
          Font.Name = #23435#20307
          Font.Style = []
          FooterColor = clWindow
          FooterFont.Charset = DEFAULT_CHARSET
          FooterFont.Color = clWindowText
          FooterFont.Height = -11
          FooterFont.Name = 'MS Sans Serif'
          FooterFont.Style = []
          FooterRowCount = 1
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          ParentFont = False
          SumList.Active = True
          TabOrder = 0
          TitleFont.Charset = ANSI_CHARSET
          TitleFont.Color = clWindowText
          TitleFont.Height = -16
          TitleFont.Name = #23435#20307
          TitleFont.Style = []
          UseMultiTitle = True
          Columns = <
            item
              EditButtons = <>
              FieldName = 'CATCAMEE'
              Footers = <>
              Title.Caption = #22823#31867#21517
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 151
            end
            item
              EditButtons = <>
              FieldName = 'MFID'
              Footers = <>
              Title.Caption = #23703#32452#21495
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 77
            end
            item
              EditButtons = <>
              FieldName = 'MFCNAME'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.Value = #21512#35745
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #23703#32452#21517#31216
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 176
            end
            item
              EditButtons = <>
              FieldName = 'XSSR'
              Footer.FieldName = 'XSSR'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #20170#24180'|'#38144#21806#37329#39069
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 76
            end
            item
              EditButtons = <>
              FieldName = 'XSSL'
              Footer.FieldName = 'XSSL'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #20170#24180'|'#38144#21806#25968#37327
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 61
            end
            item
              EditButtons = <>
              FieldName = 'VIPXSSR'
              Footer.FieldName = 'VIPXSSR'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #20170#24180'|'#36149#23486#38144#21806#37329#39069
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 78
            end
            item
              EditButtons = <>
              FieldName = 'VIPXSSL'
              Footer.FieldName = 'VIPXSSL'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #20170#24180'|'#36149#23486#38144#21806#25968#37327
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 48
            end
            item
              DisplayFormat = '0.00%'
              EditButtons = <>
              FieldName = 'VXSTB'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #20170#24180'|'#36149#23486#28040#36153#13#10#37329#39069#21344#27604
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 55
            end
            item
              DisplayFormat = '0.00%'
              EditButtons = <>
              FieldName = 'VXSLTB'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #20170#24180'|'#36149#23486#28040#36153#13#10#25968#37327#21344#27604
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 57
            end
            item
              EditButtons = <>
              FieldName = 'LASTXSSR'
              Footer.FieldName = 'LASTXSSR'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #21435#24180'|'#38144#21806#37329#39069
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
            end
            item
              EditButtons = <>
              FieldName = 'LASTXSSL'
              Footer.FieldName = 'LASTXSSL'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #21435#24180'|'#38144#21806#25968#37327
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 56
            end
            item
              EditButtons = <>
              FieldName = 'LASTVIPXSSR'
              Footer.FieldName = 'LASTVIPXSSR'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #21435#24180'|'#36149#23486#38144#21806#37329#39069
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
            end
            item
              EditButtons = <>
              FieldName = 'LASTVIPXSSL'
              Footer.FieldName = 'LASTVIPXSSL'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtSum
              Footers = <>
              Title.Caption = #21435#24180'|'#36149#23486#38144#21806#25968#37327
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 53
            end
            item
              DisplayFormat = '0.00%'
              EditButtons = <>
              FieldName = 'LVXSTB'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #21435#24180'|'#36149#23486#28040#36153#13#10#37329#39069#21344#27604
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 55
            end
            item
              DisplayFormat = '0.00%'
              EditButtons = <>
              FieldName = 'LVXSLTB'
              Footer.Font.Charset = ANSI_CHARSET
              Footer.Font.Color = clWindowText
              Footer.Font.Height = -12
              Footer.Font.Name = #23435#20307
              Footer.Font.Style = [fsBold]
              Footer.ValueType = fvtStaticText
              Footers = <>
              Title.Caption = #21435#24180'|'#36149#23486#28040#36153#13#10#25968#37327#21344#27604
              Title.Font.Charset = ANSI_CHARSET
              Title.Font.Color = clWindowText
              Title.Font.Height = -12
              Title.Font.Name = #23435#20307
              Title.Font.Style = []
              Width = 57
            end>
        end
      end
    end
  end
  object OraSession1: TOraSession
    Username = 'dbusrmkt205'
    Password = 'futuremkt'
    Server = 'm205_db'
    Connected = True
    LoginPrompt = False
    Left = 96
    Top = 40
  end
  object OraQuery1: TOraQuery
    Session = OraSession1
    SQL.Strings = (
      
        'select dl,b.catcname,sum(thisxssr) as bnxs ,sum(lastxssr) as qnx' +
        's from ('
      
        'SELECT fgetgoodscatpcode(tc.scdcatid, 1) dl, fgetgoodscatpcode(t' +
        'c.scdcatid, 2) zl,'
      
        '       fgetgoodscatpcode(tc.scdcatid, 3) catcode, SUM(nvl(thisxs' +
        'sr, 0)) thisxssr,'
      '       SUM(nvl(lastxssr, 0)) lastxssr,'
      '       decode(SUM(nvl(lastxssr, 0)), 0, 0,'
      
        '               round((SUM(nvl(thisxssr, 0)) - SUM(nvl(lastxssr, ' +
        '0))) / SUM(nvl(lastxssr, 0)), 4)) ext'
      '  FROM (SELECT scdcatid, SUM(nvl(xssr + pfsr, 0)) thisxssr'
      '           FROM salecostday, manaframe'
      
        '          WHERE salecostday.scddate <= to_date('#39'2011-01-03'#39', '#39'YY' +
        'YY-MM-DD'#39')'
      
        '            AND salecostday.scddate >= to_date('#39'2011-01-03'#39', '#39'YY' +
        'YY-MM-DD'#39')'
      '            AND salecostday.scdcatid IN (SELECT catcode'
      '                                           FROM goodscat'
      
        '                                          WHERE goodscat.catmfid' +
        ' = '#39'401'#39')'
      '            AND scdmfid = mfcode'
      '            AND mfpcode LIKE '#39#39' || '#39'%'#39
      '            AND mffcode LIKE '#39#39' || '#39'%'#39
      '          GROUP BY scdcatid) ta,'
      '       (SELECT scdcatid, SUM(nvl(xssr + pfsr, 0)) lastxssr'
      '           FROM salecostday, manaframe'
      
        '          WHERE scddate <= add_months(to_date('#39'2011-01-03'#39', '#39'YYY' +
        'Y-MM-DD'#39'), -12)'
      
        '            AND scddate >= add_months(to_date('#39'2011-01-03'#39', '#39'YYY' +
        'Y-MM-DD'#39'), -12)'
      '            AND salecostday.scdcatid IN (SELECT catcode'
      '                                           FROM goodscat'
      
        '                                          WHERE goodscat.catmfid' +
        ' = '#39'401'#39')'
      '            AND scdmfid = mfcode'
      '            AND mfpcode LIKE '#39#39' || '#39'%'#39
      '            AND mffcode LIKE '#39#39' || '#39'%'#39
      '          GROUP BY scdcatid) tb,'
      '       (SELECT catcode scdcatid'
      '           FROM goodscat'
      '          WHERE catflag = '#39'Y'#39
      '            AND goodscat.catmfid = '#39'401'#39
      '         UNION'
      '         SELECT DISTINCT scdcatid'
      '           FROM salecostday, manaframe'
      
        '          WHERE scddate <= add_months(to_date('#39'2011-01-03'#39', '#39'YYY' +
        'Y-MM-DD'#39'), -12)'
      
        '            AND scddate >= add_months(to_date('#39'2011-01-03'#39', '#39'YYY' +
        'Y-MM-DD'#39'), -12)'
      '            AND scdmfid = mfcode'
      '            AND mfpcode LIKE '#39#39' || '#39'%'#39
      '            AND mffcode LIKE '#39#39' || '#39'%'#39
      '            AND salecostday.scdcatid IN (SELECT catcode'
      '                                           FROM goodscat'
      
        '                                          WHERE goodscat.catmfid' +
        ' = '#39'401'#39')'
      '          GROUP BY scdcatid) tc'
      ' WHERE tc.scdcatid = ta.scdcatid(+)'
      '   AND tc.scdcatid = tb.scdcatid(+)'
      
        ' GROUP BY fgetgoodscatpcode(tc.scdcatid, 1), fgetgoodscatpcode(t' +
        'c.scdcatid, 2),'
      '          fgetgoodscatpcode(tc.scdcatid, 3)'
      
        'HAVING SUM(nvl(thisxssr, 0)) <> 0 OR SUM(nvl(lastxssr, 0)) <> 0 ' +
        ') simon,goodscat b'
      'where simon.dl=b.catcode'
      'group by dl,b.catcname/*'#21435#24180#26377#38144#21806#30340#20170#24180#27809#26377#38144#21806#30340#65292#20170#24180#26377#38144#21806#30340#21435#24180#27809#26377#38144#21806#30340#37117#35201#26174#31034'*/')
    OnCalcFields = OraQuery1CalcFields
    Left = 144
    Top = 40
    object OraQuery1DL: TStringField
      FieldName = 'DL'
      Size = 4000
    end
    object OraQuery1CATCNAME: TStringField
      FieldName = 'CATCNAME'
      Required = True
      Size = 40
    end
    object OraQuery1BNXS: TFloatField
      FieldName = 'BNXS'
    end
    object OraQuery1QNXS: TFloatField
      FieldName = 'QNXS'
    end
    object OraQuery1TB: TStringField
      FieldKind = fkCalculated
      FieldName = 'TB'
      Calculated = True
    end
  end
  object DataSource1: TDataSource
    DataSet = OraQuery1
    Left = 144
    Top = 72
  end
  object ConnectDialog1: TConnectDialog
    Caption = 'Connect'
    UsernameLabel = 'User Name'
    PasswordLabel = 'Password'
    ServerLabel = 'Server'
    ConnectButton = 'Connect'
    CancelButton = 'Cancel'
    Left = 56
    Top = 40
  end
  object SaveDialog1: TSaveDialog
    DefaultExt = '.xls'
    Filter = 'Microsoft Office Excel(*.xls)|*.xls'
    Left = 248
    Top = 41
  end
  object OraQuery2: TOraQuery
    Session = OraSession1
    SQL.Strings = (
      
        'select CATIDD,catidd||'#39' '#39'||goodscat.catcname AS CATCAMEE, b11080' +
        '3.MFID,Manaframe.Mfcname,'
      'b110803.XSSR,b110803.XSSL,b110803.VIPXSSR,b110803.VIPXSSL,'
      
        'round( decode(b110803.XSSR,0,0,b110803.VIPXSSR/b110803.XSSR*100)' +
        ',2)as VXSTB,'
      
        'round( decode(b110803.XSSL,0,0,b110803.VIPXSSL/b110803.XSSL*100)' +
        ',2)as VXSLTB, '
      
        'b110803.LASTXSSR,b110803.LASTXSSL,b110803.LASTVIPXSSR,b110803.LA' +
        'STVIPXSSL,'
      
        'round( decode(b110803.LASTXSSR,0,0,b110803.LASTVIPXSSR/b110803.L' +
        'ASTXSSR*100),2)as LVXSTB,'
      
        'round( decode(b110803.LASTXSSL,0,0,b110803.LASTVIPXSSL/b110803.L' +
        'ASTXSSL*100),2)as LVXSLTB'
      ' from ('
      'select a110803.*,substr(sglcatid,1,2) catidd from ('
      
        'SELECT mfid,sglcatid, SUM(nvl(instr(flag, '#39'1'#39') * xssr, 0)) xssr,' +
        ' SUM(nvl(instr(flag, '#39'1'#39') * xssl, 0)) xssl,'
      '       SUM(nvl(instr(flag, '#39'1'#39') * vipxssr, 0)) vipxssr,'
      '       SUM(nvl(instr(flag, '#39'1'#39') * vipxssl, 0)) vipxssl,'
      
        '       SUM(nvl(instr(flag, '#39'2'#39') * xssr, 0)) lastxssr, SUM(nvl(in' +
        'str(flag, '#39'2'#39') * xssl, 0)) lastxssl,'
      '       SUM(nvl(instr(flag, '#39'2'#39') * vipxssr, 0)) lastvipxssr,'
      '       SUM(nvl(instr(flag, '#39'2'#39') * vipxssl, 0)) lastvipxssl'
      
        '  FROM (SELECT '#39'1'#39' flag, sglmfid mfid,sglcatid, SUM(sglxssr) xss' +
        'r, SUM(sglsl) xssl, SUM(sglcustsr) vipxssr,'
      
        '                SUM(decode(sign(sglcustsr - 0), -1, sglsl, 1, sg' +
        'lsl, 0)) vipxssl'
      '           FROM salegoodslist'
      '          WHERE sgldate >= to_date('#39'2011-01-01'#39', '#39'yyyy-mm-dd'#39')'
      '            AND sgldate <= to_date('#39'2011-01-01'#39', '#39'yyyy-mm-dd'#39')'
      '            AND salegoodslist.sglmarket = '#39'205'#39
      
        '            AND '#39'SALEGOODSLIST.SGLMFID'#39' = '#39'SALEGOODSLIST.SGLMFID' +
        #39
      '          GROUP BY sglmfid,sglcatid'
      '         UNION ALL'
      
        '         SELECT '#39'2'#39' flag, sglmfid mfid,sglcatid, SUM(sglxssr) la' +
        'stxssr, SUM(sglsl) lastxssl,'
      '                SUM(sglcustsr) lastvipxssr,'
      
        '                SUM(decode(sign(sglcustsr - 0), -1, sglsl, 1, sg' +
        'lsl, 0)) lastvipxssl'
      '           FROM salegoodslist'
      
        '          WHERE sgldate >= add_months(to_date('#39'2011-01-01'#39', '#39'yyy' +
        'y-mm-dd'#39'), -12)'
      
        '            AND sgldate <= add_months(to_date('#39'2011-01-01'#39', '#39'yyy' +
        'y-mm-dd'#39'), -12)'
      '            AND salegoodslist.sglmarket = '#39'205'#39
      
        '            AND '#39'SALEGOODSLIST.SGLMFID'#39' = '#39'SALEGOODSLIST.SGLMFID' +
        #39
      '          GROUP BY sglmfid,sglcatid)'
      ' GROUP BY mfid,sglcatid'
      
        ' ) a110803,goodscat where sglcatid= goodscat.catcode order by mf' +
        'id'
      
        ' )  b110803,goodscat,Manaframe where catidd=goodscat.catcode and' +
        ' mfid=Manaframe.mfcode'
      ' order by b110803.MFID')
    Left = 524
    Top = 16
    object OraQuery2CATIDD: TStringField
      FieldName = 'CATIDD'
      Size = 2
    end
    object OraQuery2CATCAMEE: TStringField
      FieldName = 'CATCAMEE'
      Size = 43
    end
    object OraQuery2XSSR: TFloatField
      FieldName = 'XSSR'
    end
    object OraQuery2XSSL: TFloatField
      FieldName = 'XSSL'
    end
    object OraQuery2VIPXSSR: TFloatField
      FieldName = 'VIPXSSR'
    end
    object OraQuery2VIPXSSL: TFloatField
      FieldName = 'VIPXSSL'
    end
    object OraQuery2LASTXSSR: TFloatField
      FieldName = 'LASTXSSR'
    end
    object OraQuery2LASTXSSL: TFloatField
      FieldName = 'LASTXSSL'
    end
    object OraQuery2LASTVIPXSSR: TFloatField
      FieldName = 'LASTVIPXSSR'
    end
    object OraQuery2LASTVIPXSSL: TFloatField
      FieldName = 'LASTVIPXSSL'
    end
    object OraQuery2VXSTB: TFloatField
      FieldName = 'VXSTB'
    end
    object OraQuery2VXSLTB: TFloatField
      FieldName = 'VXSLTB'
    end
    object OraQuery2LVXSTB: TFloatField
      FieldName = 'LVXSTB'
    end
    object OraQuery2LVXSLTB: TFloatField
      FieldName = 'LVXSLTB'
    end
    object OraQuery2MFID: TStringField
      FieldName = 'MFID'
    end
    object OraQuery2MFCNAME: TStringField
      FieldName = 'MFCNAME'
      Required = True
      Size = 40
    end
  end
  object DataSource2: TDataSource
    DataSet = OraQuery2
    Left = 560
    Top = 16
  end
end
